Setting general connection properties

This section describes how to configure general connection properties. For an explanation of how to configure advanced connection properties, see Setting advanced connection properties.

To add a Microsoft Azure SQL Database target endpoint to Qlik Replicate:

1. In the Qlik Replicate Console, click Manage Endpoint Connections to open the Manage Endpoints Connections dialog box and then click New Endpoint Connection. For more information on adding an endpoint to Qlik Replicate, see Defining and managing endpoints.
2. In the Name field, type a name for your database. This can be any name that will help to identify the database being used.
3. In the Description field, type a description that helps to identify the Microsoft Azure SQL Database database. This is optional.

4. Select Target as the database role.

5. Select Microsoft Azure SQL Database as the database Type.

6. Select one of the following authentication methods:

   • SQL Authentication
   • Azure Active Directory Authentication
   • Azure Active Directory Service Principal
7. In the Username field, enter your user name for accessing the database. When Azure Active Directory Service Principal is selected, this is the Client ID.

8. In the Password field, enter your password for accessing the database. When Azure Active Directory Service Principal is selected, this is the Secret Key.

   Information note

   To ensure that the password provided to Replicate is never used by any other principal, Replicate can be configured to automatically replace the user-entered password with a strong random password. For more information, see Configuring Replicate to Automatically Replace the User-Entered Password.

   Information note

   • The username and password are case sensitive.

   • To determine if you are connected to the database you want to use or if the connection information you entered is correct, click Test Connection.

     If the connection is successful a message in green is displayed. If the connection fails, an error message is displayed at the bottom of the dialog box.

     To view the log entry if the connection fails, click View Log. The server log is displayed with the information for the connection failure. Note that this button is not available unless the test connection fails.

9. Type the Database name or click Browse and select one from the list of available databases. This is the name of the database from where you are replicating the data.

Testing the connection

To check if the connection information you entered is correct, click Test Connection.

If the connection is successful a message in green is displayed. If the connection fails, an error message is displayed at the bottom of the dialog box.

To view the log entry if the connection fails, click View Log. The server log is displayed with the information for the connection failure. Note that this button is not available unless the test connection fails.